package com.apes.fn.pi.basicInfo;

import com.apes.fn.fico.debitnote.model.LoanNote;
import com.apes.framework.jpa.repository.CustomRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * Created by lishikun on 2022/1/17 17:37
 */
public interface CaamDeptAccountRepository extends CustomRepository<CaamDeptAccount, String> {

    @Query("select T from CaamDeptAccount T where T.caamhrApiNumber is not null and T.caamhrApiPassword is not null")
    List<CaamDeptAccount> findAllByCaamhrApiNumberIsNotNull();

    @Query("select T from CaamDeptAccount T where T.caamApiNumber is not null and T.caamApiPassword is not null")
    List<CaamDeptAccount> findAllByCaamApiNumberIsNotNull();
}
